set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=300;
set hive.exec.max.dynamic.partitions.pernode=300;

insert overwrite table jms_dwd.dwd_tab_spec_piece_record_dt partition(dt)
select
id
,billcode
,spec_type
,business_id
,business_name
,create_time
,ext_info1
,ext_info2
,ext_info3
,dt
from jms_ods.tab_spec_piece_record
where dt = '{{ execution_date | cst_ds }}';